When the STARTPAGE= option is set to NO or OFF, and ODS SELECT or ODS EXCLUDE statements are used to control the output placed in an RTF file, STARTPAGE=YES or STARTPAGE=ON might not force a page break. It will be necessary to specify STARTPAGE=NOW before the ODS SELECT or ODS EXCLUDE statements in order to force a page break on tables which should appear on a separate page in the RTF file.

The example code on the Full Code tab illustrates the problem and the circumvention.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	OpenVMS on HP Integrity	9.2 TS1M0	9.3 TS1M0
		Solaris for x64	9.2 TS1M0	9.3 TS1M0
		Linux	9.2 TS1M0	9.3 TS1M0
		Linux for x64	9.2 TS1M0	9.3 TS1M0
		HP-UX IPF	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled HP-UX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled Solaris	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled AIX	9.2 TS1M0	9.3 TS1M0
		Windows Vista	9.2 TS1M0	9.3 TS1M0
		Windows Vista for x64	9.2 TS1M0	9.3 TS1M0
		z/OS	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for x64	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP Professional	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS1M0	9.3 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

The sample code below creates two RTF files. PROBLEM.RTF does not paginate with the STARTPAGE=YES option in effect. SOLUTION.RTF uses the STARTPAGE=NOW option before the ODS EXCLUDE block to create the desired page break.

---

/* The following code illustrates the problem */

ods rtf file="problem.rtf";
ods rtf startpage=no;

proc report data=sashelp.class nowd missing;
run;

/* Change to STARTPAGE=NOW to work in SAS 9.2 */
ods rtf startpage=yes;
ods exclude all;

proc datasets lib=work;
run;
quit;

ods exclude none;
ods rtf startpage=yes;

proc report data=sashelp.class nowd missing;
run;

ods rtf close;


/* The following code illustrates the workaround */

ods rtf file="solution.rtf";
ods rtf startpage=no;

proc report data=sashelp.class nowd missing;
run;

/* Changed to STARTPAGE=NOW to work in SAS 9.2 */
ods rtf startpage=now;
ods exclude all;

proc datasets lib=work;
run;
quit;

ods exclude none;
ods rtf startpage=yes;

proc report data=sashelp.class nowd missing;
run;

ods rtf close;

Type:	Problem Note
Priority:	medium

Date Modified:	2010-10-25 14:43:03
Date Created:	2010-10-07 13:59:32